NTISthis.com

Evidence Guide: BSBITA411 - Design and develop relational databases

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

BSBITA411 - Design and develop relational databases

What evidence can you provide to prove your understanding of each of the following citeria?

Design database

  1. Identify organisational and task requirements to confirm scope and functionality of database design, including data redundancy
  2. Develop a logical data model to identify and classify data into types in accordance with organisational and task requirements
  3. Select appropriate digital application/platform according to organisational and task requirements, available resources, and required scope and functionality of database
  4. Create and document proposed database structure, and share with appropriate personnel in accordance with organisational policies and procedures
  5. Seek feedback on proposed database design from appropriate personnel
Identify organisational and task requirements to confirm scope and functionality of database design, including data redundancy

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Develop a logical data model to identify and classify data into types in accordance with organisational and task requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Select appropriate digital application/platform according to organisational and task requirements, available resources, and required scope and functionality of database

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create and document proposed database structure, and share with appropriate personnel in accordance with organisational policies and procedures

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Seek feedback on proposed database design from appropriate personnel

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Develop database

  1. Set field attributes according to data type and link databases by a common field in accordance with database application usage
  2. Assign primary key to uniquely identify data
  3. Assign foreign keys to establish associations between data, in accordance with organisational and task requirements
  4. Use software functions and formulae to meet organisational and task requirements
  5. Create password and access system according to organisational policies and procedures relating to data security
  6. Access and use application help functions to overcome intermediate-level issues with database design and production, where required
Set field attributes according to data type and link databases by a common field in accordance with database application usage

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assign primary key to uniquely identify data

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assign foreign keys to establish associations between data, in accordance with organisational and task requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use software functions and formulae to meet organisational and task requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create password and access system according to organisational policies and procedures relating to data security

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Access and use application help functions to overcome intermediate-level issues with database design and production, where required

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Develop queries, forms and reports

  1. Identify information output, database tables to be use and report layout, in accordance with task requirements
  2. Identify data groupings, search and sort criteria, in accordance with task requirements
  3. Run reports and queries to confirm that results and formulae produce required data
  4. Modify reports to include or exclude additional requirements, where necessary
Identify information output, database tables to be use and report layout, in accordance with task requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Identify data groupings, search and sort criteria, in accordance with task requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Run reports and queries to confirm that results and formulae produce required data

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Modify reports to include or exclude additional requirements, where necessary

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Test and finalise database

  1. Populate database with sample dataset for testing, meeting organisational requirements for speed and accuracy
  2. Assess and document effectiveness of data relationships, query forms and reports, assessing against organisational and task requirements
  3. Document and address any errors in database design
  4. Name and store database in accordance with organisational policies and procedures relating to data security, and exit the application without data loss or damage
  5. Confirm database readiness with appropriate personnel
  6. Identify organisational and task requirements to confirm scope and functionality of database design, including data redundancy
  7. Develop a logical data model to identify and classify data into types in accordance with organisational and task requirements
  8. Select appropriate digital application/platform according to organisational and task requirements, available resources, and required scope and functionality of database
  9. Create and document proposed database structure, and share with appropriate personnel in accordance with organisational policies and procedures
  10. Seek feedback on proposed database design from appropriate personnel
  11. Set field attributes according to data type and link databases by a common field in accordance with database application usage
  12. Assign primary key to uniquely identify data
  13. Assign foreign keys to establish associations between data, in accordance with organisational and task requirements
  14. Use software functions and formulae to meet organisational and task requirements
  15. Create password and access system according to organisational policies and procedures relating to data security
  16. Access and use application help functions to overcome intermediate-level issues with database design and production, where required
Populate database with sample dataset for testing, meeting organisational requirements for speed and accuracy

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assess and document effectiveness of data relationships, query forms and reports, assessing against organisational and task requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Document and address any errors in database design

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Name and store database in accordance with organisational policies and procedures relating to data security, and exit the application without data loss or damage

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Confirm database readiness with appropriate personnel

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Identify organisational and task requirements to confirm scope and functionality of database design, including data redundancy

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Develop a logical data model to identify and classify data into types in accordance with organisational and task requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Select appropriate digital application/platform according to organisational and task requirements, available resources, and required scope and functionality of database

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create and document proposed database structure, and share with appropriate personnel in accordance with organisational policies and procedures

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Seek feedback on proposed database design from appropriate personnel

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Set field attributes according to data type and link databases by a common field in accordance with database application usage

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assign primary key to uniquely identify data

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assign foreign keys to establish associations between data, in accordance with organisational and task requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use software functions and formulae to meet organisational and task requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create password and access system according to organisational policies and procedures relating to data security

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Access and use application help functions to overcome intermediate-level issues with database design and production, where required

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Required Skills and Knowledge